Tables [dbo].[QueryResultMain]
SQLServer > iMIS1521GA > Tables > dbo.QueryResultMain
Properties
PropertyValue
Row Count1044
Created10:31:35 AM Tuesday, March 02, 2010
Last Modified1:20:16 PM Thursday, February 23, 2012
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_QueryResultMain: QueryResultKeyQueryResultKeyuniqueidentifier16
No
(newid())
Foreign Keys FK_QueryResultMain_UserMain_CreatedBy: [dbo].[UserMain].CreatedByUserKeyIndexes IX_QueryResultMain_CreatedByUserKey: CreatedByUserKeyCreatedByUserKeyuniqueidentifier16
No
CreatedOndatetime8
No
(getdate())
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_QueryResultMain: QueryResultKeyPK_QueryResultMainQueryResultKey
Yes
IX_QueryResultMain_CreatedByUserKeyCreatedByUserKey
Foreign Keys Foreign Keys
NameColumns
FK_QueryResultMain_UserMain_CreatedByCreatedByUserKey->[dbo].[UserMain].[UserKey]
SQL Script
CREATE TABLE [dbo].[QueryResultMain]
(
[QueryResultKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_QueryResultMain_QueryResultKey] DEFAULT (newid()),
[CreatedByUserKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_QueryResultMain_CreatedOn] DEFAULT (getdate())
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[QueryResultMain] ADD CONSTRAINT [PK_QueryResultMain] PRIMARY KEY CLUSTERED ([QueryResultKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_QueryResultMain_CreatedByUserKey] ON [dbo].[QueryResultMain] ([CreatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QueryResultMain] ADD CONSTRAINT [FK_QueryResultMain_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
Uses
Used By
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved